
select ea.id,ea.name,e.name 'Entity',ea.ActionAssembly,ea.ActionClass, ea.ActionObject from vwEntityActions ea 
inner join Entity e on e.id=ea.EntityID
where ea.ActionClass
not in (
'Aptify.Framework.DataPacker.DataPackerWizardForm'
,'Aptify.Framework.DataPacker.DataUnpackerWizardForm'
,'Aptify.Framework.EntityPacker.EntityPackerGUI'
,'Aptify.Framework.EntityPacker.EntityPackerAction'
,'Aptify.Framework.DataPacker.DataPackerWizardForm'
,'Aptify.Framework.DataPacker.DataUnpackerWizardForm'
,'Aptify.Framework.DataPacker.DataPackerWizardForm'
,'Aptify.Framework.DataPacker.DataUnpackerWizardForm'
,'Aptify.Framework.DataPacker.DataPackerWizardForm'
,'Aptify.Framework.DataPacker.DataUnpackerWizardForm'
,'Aptify.Framework.DataPacker.DataPackerWizardForm'
,'Aptify.Framework.DataPacker.DataUnpackerWizardForm'
,'Aptify.Framework.DataPacker.DataPackerWizardForm'
,'Aptify.Framework.DataPacker.DataUnpackerWizardForm'
,'Aptify.Framework.DataPacker.DataPackerWizardForm'
,'Aptify.Framework.DataPacker.DataUnpackerWizardForm'
,'Aptify.Framework.DataPacker.DataPackerWizardForm'
,'Aptify.Framework.DataPacker.DataUnpackerWizardForm'
,'Aptify.Framework.DataPacker.DataPackerWizardForm'
,'Aptify.Framework.DataPacker.DataUnpackerWizardForm'
,'Aptify.Framework.DataPacker.DataPackerWizardForm'
,'Aptify.Framework.DataPacker.DataUnpackerWizardForm'
,'Aptify.Framework.GenericImport.GenericImportGUI'
,'Aptify.Framework.Replication.Wizards.PubWizardForm'
,'Aptify.Framework.Replication.Wizards.SubscribeWizardForm'
,'Aptify.Framework.Replication.Wizards.SynchWizardForm'
,'Aptify.Applications.Accounting.LockBoxWizard'
,'Aptify.Applications.InventoryManagement.BulkInventoryTransferWizard'
,'Aptify.Applications.InventoryManagement.InventoryReturnWizardForm'
,'Aptify.Applications.Accounting.ExpandScheduledTransactions'
,'Aptify.Applications.OrderEntry.Payments.CaptureWizForm'
,'Aptify.Applications.Campaigns.CampaignSetupWizard'
,'Aptify.Applications.ExpoManagement.FloorplanCopyWizard'
,'Aptify.Applications.Persons.Committees.AddPersonToCommitteesUI'
,'Aptify.Applications.Campaigns.AddToCampaign'
,'Aptify.Applications.ContactManagement.OutlookContactLogImportWizard'
,'Aptify.Applications.Persons.OutlookSyncWizard'
,'Aptify.Framework.MicrosoftWord.TemplateWizardForm'
,'Aptify.Applications.ExpoManagement.BoothCombinationWizard'
,'Aptify.Applications.Campaigns.ListImport.CampaignImportWizard'
,'Aptify.Applications.Housing.HousingTransferWizard'
,'Aptify.Applications.Housing.HousingImportWizard'
,'Aptify.Applications.Accounting.StandingOrderFulfillmentWizard'
,'Aptify.Applications.Subscriptions.SubscriptionRenewal'
,'Aptify.Applications.Campaigns.AddToCampaign'
,'Aptify.Framework.Administration.VirtualEntityWizard'
,'Aptify.Applications.OrderEntry.CancellationWizForm'
,'Aptify.Applications.Accounting.Currency.MarkToMarketWizard'
,'Aptify.Applications.Accounting.BatchWizard'
,'Aptify.Framework.Misc.SampleDataLoaderWizard'
,'Aptify.Applications.Accounting.BatchWizard'
,'Aptify.Applications.ProductSetup.NewProductVersionWizard'
,'Aptify.Applications.Campaigns.CampaignListBuilderWizard'
,'Aptify.Framework.Licensing.LicenseImportWizard'
,'Aptify.Applications.Accounting.AP.ExportWizard'
,'Aptify.Applications.Accounting.AP.ImportWizard'
,'Aptify.Applications.Accounting.InvoiceConsolidationWizard'
,'Aptify.Applications.Accounting.BatchWizard'
,'Aptify.Framework.BusinessLogic.ProcessPipeline.ProcessFlowDebugRun'
,'Aptify.Framework.BusinessLogic.GenericEntity.ServiceGeneratorForm'
,'Aptify.Applications.OrderEntry.WindowsControls.BulkOrdersWizard'
,'Aptify.Applications.OrderEntry.WindowsControls.BulkOrdersWizard'
,'Aptify.Framework.DataPacker.DataPackerWizardForm'
,'Aptify.Framework.DataPacker.DataUnpackerWizardForm'
,'Aptify.Applications.CaseManagement.clsNewCase'
,'Aptify.Applications.CommitteeTerm.CommitteeRenewalWizardForm'
,'Aptify.Applications.Expos.FloorplanIntegration.SyncWizard'
,'Aptify.Framework.Formtemplate.FormTemplateCopier'
,'Aptify.Applications.Commissions.CommissionPaymentWizard'
,'Aptify.Applications.Fundraising.PledgeMatchingObject'
,'Aptify.Applications.Fundraising.ContributionPaymentWizard'
,'Aptify.Framework.Messaging.frmScheduleMessage'
,'Aptify.Applications.Education.CertificatePrintWizard'
,'Aptify.Applications.Education.ClassRegistrationWizard'
,'Aptify.Applications.Education.ScantronImportWizard'
,'Aptify.Framework.Web.eBusiness.Tools.EntityUserControlGeneratorWizard'
,'Aptify.Applications.Accounting.AP.ExportWizard'
,'Aptify.Applications.Accounting.AP.ImportWizard'
,'Aptify.Framework.BusinessLogic.ProcessPipeline.WebServicesMethodGeneratorForm'
,'Aptify.Framework.BusinessLogic.ProcessPipeline.GenerateDataMapperProcessComponent'
,'Aptify.Applications.OrderEntry.ScheduledMeetingTransferWizForm'
,'Aptify.Applications.OrderEntry.Payments.CreditCardPurgeForm'
,'Aptify.Applications.OrderEntry.ScheduledMeetingTransferWizForm'
,'Aptify.Applications.OrderEntry.Payments.PaymentRefundWizForm'
,'Aptify.Framework.BusinessLogic.ProcessPipeline.ProcessFlowCopier'
,'Aptify.Framework.Integration.TopicCodeSynchronizationForm'
,'Aptify.Framework.Integration.UserSynchronizationForm'
)
order by id desc

